Create
a new table modelCreate
a new table model
General
step:
-
Select Referral program Table
-
Click ReferralName
-
Click Filter and unselect this Names Job Ref, 123, Sales Repand
all Name's start with Test
Step
1
- Copy pest Referral program
Table 4 times
- Rename the first table Referee
- Rename the Second t table Members
- Rename the third table Commission1
- Rename the third table Commission2
Step
2
Create a Referee table
- Select Refm_Startdate, Comission1
Reached, Comission2 Reached, RFM_Amount columns (By Using hold ctrl and click
the columns)
- Click Remove Columns
Step
3
Create Members table
- Select RFM_Reward
level, MemberName, ReferralName, Refm_Startdate columns (By Using hold ctrl and
Click the columns)
- Click Remove Column and
Select Remove Other Columns
Step
4
Create Commission1 table
- Select ReferralName, Refm_Startdate, Registrationdate, Commission2 Columns (By Using hold ctrl and click the
columns)
- Click Remove Column
Step
5
Create Commission2 table
- Select ReferralName, Refm_Startdate, Registrationdate, Commission1 Columns (By Using hold ctrl and click the
columns)
- Click Remove Column
